CREATE VIEW [dbo].[vSoaGroupMemberDetailCommittee]
WITH SCHEMABINDING
AS
    SELECT  CAST([p2].[PRODUCT_CODE] + ':' + [a].[ID] + ':'
            + CAST([a].[SEQN] AS VARCHAR(10)) AS VARCHAR(50)) AS [GroupMemberDetailId],
            CAST([p2].[PRODUCT_CODE] + ':' + [a].[ID] AS VARCHAR(50)) AS [GroupMemberId],
            [a].[ID] AS [PartyId],
            [a].[EFFECTIVE_DATE] AS [EffectiveDate],
            [a].[THRU_DATE] AS [ExpirationDate],
            [a].[ACTION_CODES]
      FROM  [dbo].[Activity] AS [a]
            INNER JOIN [dbo].[Product] AS [p2] ON [a].[PRODUCT_CODE] = [p2].[PRODUCT_CODE]
     WHERE  ( [p2].[PROD_TYPE] = 'COMMITTEE' )


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupMemberDetailCommittee] ON [dbo].[vSoaGroupMemberDetailCommittee] ([GroupMemberDetailId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberDetailCommittee_GroupMemberId] ON [dbo].[vSoaGroupMemberDetailCommittee] ([GroupMemberId]) ON [PRIMARY]
GO